﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="kartrisOrdersData" targetNamespace="http://tempuri.org/kartrisOrdersData.xsd" xmlns:mstns="http://tempuri.org/kartrisOrdersData.xsd" xmlns="http://tempuri.org/kartrisOrdersData.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="KartrisSQLConnection" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="KartrisSQLConnection (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.KartrisSQLConnection.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrdersTblAdptr" GeneratorDataComponentClassName="OrderstblAdptr" Name="Orders" UserDataComponentName="OrdersTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisOrders_Get" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisOrders_Get</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@O_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="O_ID" DataSetColumn="O_ID" />
              <Mapping SourceColumn="O_CustomerID" DataSetColumn="O_CustomerID" />
              <Mapping SourceColumn="O_Details" DataSetColumn="O_Details" />
              <Mapping SourceColumn="O_ShippingPrice" DataSetColumn="O_ShippingPrice" />
              <Mapping SourceColumn="O_ShippingTax" DataSetColumn="O_ShippingTax" />
              <Mapping SourceColumn="O_DiscountPercentage" DataSetColumn="O_DiscountPercentage" />
              <Mapping SourceColumn="O_AffiliatePercentage" DataSetColumn="O_AffiliatePercentage" />
              <Mapping SourceColumn="O_TotalPrice" DataSetColumn="O_TotalPrice" />
              <Mapping SourceColumn="O_Date" DataSetColumn="O_Date" />
              <Mapping SourceColumn="O_PurchaseOrderNo" DataSetColumn="O_PurchaseOrderNo" />
              <Mapping SourceColumn="O_SecurityID" DataSetColumn="O_SecurityID" />
              <Mapping SourceColumn="O_Sent" DataSetColumn="O_Sent" />
              <Mapping SourceColumn="O_Invoiced" DataSetColumn="O_Invoiced" />
              <Mapping SourceColumn="O_Shipped" DataSetColumn="O_Shipped" />
              <Mapping SourceColumn="O_Paid" DataSetColumn="O_Paid" />
              <Mapping SourceColumn="O_Status" DataSetColumn="O_Status" />
              <Mapping SourceColumn="O_LastModified" DataSetColumn="O_LastModified" />
              <Mapping SourceColumn="O_WishListID" DataSetColumn="O_WishListID" />
              <Mapping SourceColumn="O_CouponCode" DataSetColumn="O_CouponCode" />
              <Mapping SourceColumn="O_CouponDiscountTotal" DataSetColumn="O_CouponDiscountTotal" />
              <Mapping SourceColumn="O_PricesIncTax" DataSetColumn="O_PricesIncTax" />
              <Mapping SourceColumn="O_TaxDue" DataSetColumn="O_TaxDue" />
              <Mapping SourceColumn="O_PaymentGateWay" DataSetColumn="O_PaymentGateWay" />
              <Mapping SourceColumn="O_ReferenceCode" DataSetColumn="O_ReferenceCode" />
              <Mapping SourceColumn="O_LanguageID" DataSetColumn="O_LanguageID" />
              <Mapping SourceColumn="O_CurrencyID" DataSetColumn="O_CurrencyID" />
              <Mapping SourceColumn="O_TotalPriceGateway" DataSetColumn="O_TotalPriceGateway" />
              <Mapping SourceColumn="O_CurrencyIDGateway" DataSetColumn="O_CurrencyIDGateway" />
              <Mapping SourceColumn="O_AffiliatePaymentID" DataSetColumn="O_AffiliatePaymentID" />
              <Mapping SourceColumn="O_AffiliateTotalPrice" DataSetColumn="O_AffiliateTotalPrice" />
              <Mapping SourceColumn="O_SendOrderUpdateEmail" DataSetColumn="O_SendOrderUpdateEmail" />
              <Mapping SourceColumn="O_OrderHandlingCharge" DataSetColumn="O_OrderHandlingCharge" />
              <Mapping SourceColumn="O_OrderHandlingChargeTax" DataSetColumn="O_OrderHandlingChargeTax" />
              <Mapping SourceColumn="O_CurrencyRate" DataSetColumn="O_CurrencyRate" />
              <Mapping SourceColumn="O_BillingAddress" DataSetColumn="O_BillingAddress" />
              <Mapping SourceColumn="O_ShippingAddress" DataSetColumn="O_ShippingAddress" />
              <Mapping SourceColumn="O_PromotionDiscountTotal" DataSetColumn="O_PromotionDiscountTotal" />
              <Mapping SourceColumn="O_PromotionDescription" DataSetColumn="O_PromotionDescription" />
              <Mapping SourceColumn="O_SentToQB" DataSetColumn="O_SentToQB" />
              <Mapping SourceColumn="O_Notes" DataSetColumn="O_Notes" />
              <Mapping SourceColumn="O_ShippingMethod" DataSetColumn="O_ShippingMethod" />
              <Mapping SourceColumn="O_Data" DataSetColumn="O_Data" />
              <Mapping SourceColumn="O_Comments" DataSetColumn="O_Comments" />
              <Mapping SourceColumn="O_Cancelled" DataSetColumn="O_Cancelled" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisOrders_Delete]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_Delete" Modifier="Public" Name="_Delete" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="_Delete">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_Delete]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@O_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@O_DeleteReturnStock" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisOrders_GetByStatusCount]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_GetByStatusCount" Modifier="Public" Name="_GetByStatusCount" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="_GetByStatusCount">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_GetByStatusCount]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Callmode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@O_AffiliatePaymentID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@O_DateRangeStart" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@O_DateRangeEnd" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@O_Gateway" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@O_GatewayID" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisOrders_GetChildOrderID]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy9" GeneratorSourceName="_GetChildOrderID" Modifier="Public" Name="_GetChildOrderID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="_GetChildOrderID">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_GetChildOrderID]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@O_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisOrders_GetCustomerTotal]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_GetCustomerTotal" Modifier="Public" Name="_GetCustomerTotal" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="_GetCustomerTotal">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_GetCustomerTotal]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisOrders_GetByStatus]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetDataByStatus" GeneratorSourceName="_FillByStatus" GetMethodModifier="Public" GetMethodName="_GetDataByStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetDataByStatus" UserSourceName="_GetDataByStatus">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_GetByStatus]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Callmode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@O_AffiliatePaymentID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@O_DateRangeStart" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@O_DateRangeEnd" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@O_Gateway" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@O_GatewayID" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@PageIndex" Precision="3" ProviderType="TinyInt" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@Limit" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisOrders_GetParentOrderID]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_GetParentOrderID" Modifier="Public" Name="_GetParentOrderID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="_GetParentOrderID">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_GetParentOrderID]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@O_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisOrders_GetTileAppData]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetTileAppData" GetMethodModifier="Public" GetMethodName="_GetTileAppData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetTileAppData" UserSourceName="_GetTileAppData">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_GetTileAppData]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Sent" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Invoiced" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Paid" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Shipped" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Cancelled" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@DateRangeStart" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@DateRangeEnd" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RangeInMinutes" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisOrders_PurgeOrders]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_PurgeOrders" Modifier="Public" Name="_PurgeOrders" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="_PurgeOrders">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_PurgeOrders]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@O_PurgeDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisOrders_ToPurgeOrdersList]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_ToPurgeOrdersList" GetMethodModifier="Public" GetMethodName="_ToPurgeOrdersList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_ToPurgeOrdersList" UserSourceName="_ToPurgeOrdersList">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_ToPurgeOrdersList]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@O_PurgeDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.spKartrisOrders_GetAffiliateCommission" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy10" GeneratorSourceName="GetAffiliateCommission" Modifier="Public" Name="GetAffiliateCommission" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="GetAffiliateCommission">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisOrders_GetAffiliateCommission</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AffiliateID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.spKartrisOrders_GetQBQueue" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetQBQueue" GetMethodModifier="Public" GetMethodName="GetQBQueue" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetQBQueue" UserSourceName="GetQBQueue">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisOrders_GetQBQueue</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.spKartrisOrders_CouponUsed" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy8" GeneratorSourceName="OrderCouponUsed" Modifier="Public" Name="OrderCouponUsed" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="OrderCouponUsed">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisOrders_CouponUsed</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CouponCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="25" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.spKartrisOrders_UpdateByReferenceCode" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateByReferenceCode" Modifier="Public" Name="UpdateByReferenceCode" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy8" UserSourceName="UpdateByReferenceCode">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="true">
                    <CommandText>dbo.spKartrisOrders_UpdateByReferenceCode</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@O_ReferenceCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@O_LastModified" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@O_Sent" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@O_Invoiced" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@O_Paid" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@O_Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="500000" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.spKartrisOrders_UpdateQBSent" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateQBSent" Modifier="Public" Name="UpdateQBSent" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy9" UserSourceName="UpdateQBSent">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisOrders_UpdateQBSent</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@O_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InvoiceRowsTblAdptr" GeneratorDataComponentClassName="InvoiceRowsTblAdptr" Name="InvoiceRows" UserDataComponentName="InvoiceRowsTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="KartrisSQL.dbo.[_spKartrisOrders_GetInvoiceRows]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetInvoiceRows" GetMethodModifier="Public" GetMethodName="GetInvoiceRows" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetInvoiceRows" UserSourceName="GetInvoiceRows">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisOrders_GetInvoiceRows]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@OrderID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IR_VersionCode" DataSetColumn="IR_VersionCode" />
              <Mapping SourceColumn="IR_VersionName" DataSetColumn="IR_VersionName" />
              <Mapping SourceColumn="IR_PricePerItem" DataSetColumn="IR_PricePerItem" />
              <Mapping SourceColumn="IR_TaxPerItem" DataSetColumn="IR_TaxPerItem" />
              <Mapping SourceColumn="IR_OptionsText" DataSetColumn="IR_OptionsText" />
              <Mapping SourceColumn="V_ID" DataSetColumn="V_ID" />
              <Mapping SourceColumn="V_Live" DataSetColumn="V_Live" />
              <Mapping SourceColumn="V_Quantity" DataSetColumn="V_Quantity" />
              <Mapping SourceColumn="V_Type" DataSetColumn="V_Type" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CardTypesTblAdptr" GeneratorDataComponentClassName="CardTypesTblAdptr" Name="CardTypes" UserDataComponentName="CardTypesTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.spKartrisOrders_GetCardTypeList" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetCardTypeList" GetMethodModifier="Public" GetMethodName="GetCardTypeList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetCardTypeList" UserSourceName="GetCardTypeList">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisOrders_GetCardTypeList</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CR_NAME" DataSetColumn="CR_NAME" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PaymentsTblAdptr" GeneratorDataComponentClassName="PaymentsTblAdptr" Name="Payments" UserDataComponentName="PaymentsTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisPayments_Get]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="_Get" GetMethodModifier="Public" GetMethodName="_Get" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="_Get" UserSourceName="_Get">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisPayments_Get]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Payment_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Payment_ID" DataSetColumn="Payment_ID" />
              <Mapping SourceColumn="Payment_CustomerID" DataSetColumn="Payment_CustomerID" />
              <Mapping SourceColumn="Payment_Date" DataSetColumn="Payment_Date" />
              <Mapping SourceColumn="Payment_Amount" DataSetColumn="Payment_Amount" />
              <Mapping SourceColumn="Payment_CurrencyID" DataSetColumn="Payment_CurrencyID" />
              <Mapping SourceColumn="Payment_ReferenceNo" DataSetColumn="Payment_ReferenceNo" />
              <Mapping SourceColumn="Payment_Gateway" DataSetColumn="Payment_Gateway" />
              <Mapping SourceColumn="Payment_CurrencyRate" DataSetColumn="Payment_CurrencyRate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="[kartrisSQL_1.4].dbo.[_spKartrisPayments_Delete]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_Delete" Modifier="Public" Name="_Delete" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="_Delete">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisPayments_Delete]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Payment_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="[kartrisSQL_1.4].dbo.[_spKartrisPayments_DeleteLinkedOrders]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_DeleteLinkedOrders" Modifier="Public" Name="_DeleteLinkedOrders" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="_DeleteLinkedOrders">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisPayments_DeleteLinkedOrders]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@OP_PaymentID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisPayments_GetByCustomerID]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetByCustomerID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="_GetByCustomerID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetByCustomerID" UserSourceName="_GetByCustomerID">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisPayments_GetByCustomerID]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Payment_CustomerID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL.dbo.[_spKartrisPayments_GetCustomerTotal]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="_GetCustomerTotal" Modifier="Public" Name="_GetCustomerTotal" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="_GetCustomerTotal">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisPayments_GetCustomerTotal]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="[kartrisSQL_1.4].dbo.[_spKartrisPayments_GetFilteredList]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetFilteredList" GetMethodModifier="Public" GetMethodName="_GetFilteredList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetFilteredList" UserSourceName="_GetFilteredList">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisPayments_GetFilteredList]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@FilterType" Precision="0" ProviderType="NVarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Payment_Gateway" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Payment_Date" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@PageIndex" Precision="3" ProviderType="TinyInt" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@Limit" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="[kartrisSQL_1.4].dbo.[_spKartrisPayments_GetFilteredList_s]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_GetFilteredListCount" Modifier="Public" Name="_GetFilteredListCount" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="_GetFilteredListCount">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisPayments_GetFilteredList_s]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@FilterType" Precision="0" ProviderType="NVarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Payment_Gateway" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Payment_Date" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="[kartrisSQL_1.4].dbo.[_spKartrisPayments_GetLinkedOrders]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetLinkedOrders" GetMethodModifier="Public" GetMethodName="_GetLinkedOrders" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetLinkedOrders" UserSourceName="_GetLinkedOrders">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisPayments_GetLinkedOrders]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Payment_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="kartrisOrdersData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="kartrisOrdersData" msprop:Generator_UserDSName="kartrisOrdersData">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Orders" msprop:Generator_UserTableName="Orders" msprop:Generator_RowEvArgName="OrdersRowChangeEvent" msprop:Generator_TableVarName="tableOrders" msprop:Generator_TablePropName="Orders" msprop:Generator_RowDeletingName="OrdersRowDeleting" msprop:Generator_RowChangingName="OrdersRowChanging" msprop:Generator_RowDeletedName="OrdersRowDeleted" msprop:Generator_RowEvHandlerName="OrdersRowChangeEventHandler" msprop:Generator_TableClassName="OrdersDataTable" msprop:Generator_RowChangedName="OrdersRowChanged" msprop:Generator_RowClassName="OrdersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="O_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnO_ID" msprop:Generator_ColumnPropNameInRow="O_ID" msprop:Generator_ColumnPropNameInTable="O_IDColumn" msprop:Generator_UserColumnName="O_ID" type="xs:int" />
              <xs:element name="O_CustomerID" msprop:Generator_ColumnVarNameInTable="columnO_CustomerID" msprop:Generator_ColumnPropNameInRow="O_CustomerID" msprop:Generator_ColumnPropNameInTable="O_CustomerIDColumn" msprop:Generator_UserColumnName="O_CustomerID" type="xs:int" minOccurs="0" />
              <xs:element name="O_Details" msprop:Generator_ColumnVarNameInTable="columnO_Details" msprop:Generator_ColumnPropNameInRow="O_Details" msprop:Generator_ColumnPropNameInTable="O_DetailsColumn" msprop:Generator_UserColumnName="O_Details" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_ShippingPrice" msprop:Generator_ColumnVarNameInTable="columnO_ShippingPrice" msprop:Generator_ColumnPropNameInRow="O_ShippingPrice" msprop:Generator_ColumnPropNameInTable="O_ShippingPriceColumn" msprop:Generator_UserColumnName="O_ShippingPrice" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_ShippingTax" msprop:Generator_ColumnVarNameInTable="columnO_ShippingTax" msprop:Generator_ColumnPropNameInRow="O_ShippingTax" msprop:Generator_ColumnPropNameInTable="O_ShippingTaxColumn" msprop:Generator_UserColumnName="O_ShippingTax" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_DiscountPercentage" msprop:Generator_ColumnVarNameInTable="columnO_DiscountPercentage" msprop:Generator_ColumnPropNameInRow="O_DiscountPercentage" msprop:Generator_ColumnPropNameInTable="O_DiscountPercentageColumn" msprop:Generator_UserColumnName="O_DiscountPercentage" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_AffiliatePercentage" msprop:Generator_ColumnVarNameInTable="columnO_AffiliatePercentage" msprop:Generator_ColumnPropNameInRow="O_AffiliatePercentage" msprop:Generator_ColumnPropNameInTable="O_AffiliatePercentageColumn" msprop:Generator_UserColumnName="O_AffiliatePercentage" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_TotalPrice" msprop:Generator_ColumnVarNameInTable="columnO_TotalPrice" msprop:Generator_ColumnPropNameInRow="O_TotalPrice" msprop:Generator_ColumnPropNameInTable="O_TotalPriceColumn" msprop:Generator_UserColumnName="O_TotalPrice" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_Date" msprop:Generator_ColumnVarNameInTable="columnO_Date" msprop:Generator_ColumnPropNameInRow="O_Date" msprop:Generator_ColumnPropNameInTable="O_DateColumn" msprop:Generator_UserColumnName="O_Date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="O_PurchaseOrderNo" msprop:Generator_ColumnVarNameInTable="columnO_PurchaseOrderNo" msprop:Generator_ColumnPropNameInRow="O_PurchaseOrderNo" msprop:Generator_ColumnPropNameInTable="O_PurchaseOrderNoColumn" msprop:Generator_UserColumnName="O_PurchaseOrderNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_SecurityID" msprop:Generator_ColumnVarNameInTable="columnO_SecurityID" msprop:Generator_ColumnPropNameInRow="O_SecurityID" msprop:Generator_ColumnPropNameInTable="O_SecurityIDColumn" msprop:Generator_UserColumnName="O_SecurityID" type="xs:int" minOccurs="0" />
              <xs:element name="O_Sent" msprop:Generator_ColumnVarNameInTable="columnO_Sent" msprop:Generator_ColumnPropNameInRow="O_Sent" msprop:Generator_ColumnPropNameInTable="O_SentColumn" msprop:Generator_UserColumnName="O_Sent" type="xs:boolean" minOccurs="0" />
              <xs:element name="O_Invoiced" msprop:Generator_ColumnVarNameInTable="columnO_Invoiced" msprop:Generator_ColumnPropNameInRow="O_Invoiced" msprop:Generator_ColumnPropNameInTable="O_InvoicedColumn" msprop:Generator_UserColumnName="O_Invoiced" type="xs:boolean" minOccurs="0" />
              <xs:element name="O_Shipped" msprop:Generator_ColumnVarNameInTable="columnO_Shipped" msprop:Generator_ColumnPropNameInRow="O_Shipped" msprop:Generator_ColumnPropNameInTable="O_ShippedColumn" msprop:Generator_UserColumnName="O_Shipped" type="xs:boolean" minOccurs="0" />
              <xs:element name="O_Paid" msprop:Generator_ColumnVarNameInTable="columnO_Paid" msprop:Generator_ColumnPropNameInRow="O_Paid" msprop:Generator_ColumnPropNameInTable="O_PaidColumn" msprop:Generator_UserColumnName="O_Paid" type="xs:boolean" minOccurs="0" />
              <xs:element name="O_Status" msprop:Generator_ColumnVarNameInTable="columnO_Status" msprop:Generator_ColumnPropNameInRow="O_Status" msprop:Generator_ColumnPropNameInTable="O_StatusColumn" msprop:Generator_UserColumnName="O_Status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_LastModified" msprop:Generator_ColumnVarNameInTable="columnO_LastModified" msprop:Generator_ColumnPropNameInRow="O_LastModified" msprop:Generator_ColumnPropNameInTable="O_LastModifiedColumn" msprop:Generator_UserColumnName="O_LastModified" type="xs:dateTime" minOccurs="0" />
              <xs:element name="O_WishListID" msprop:Generator_ColumnVarNameInTable="columnO_WishListID" msprop:Generator_ColumnPropNameInRow="O_WishListID" msprop:Generator_ColumnPropNameInTable="O_WishListIDColumn" msprop:Generator_UserColumnName="O_WishListID" type="xs:int" minOccurs="0" />
              <xs:element name="O_CouponCode" msprop:Generator_ColumnVarNameInTable="columnO_CouponCode" msprop:Generator_ColumnPropNameInRow="O_CouponCode" msprop:Generator_ColumnPropNameInTable="O_CouponCodeColumn" msprop:Generator_UserColumnName="O_CouponCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_CouponDiscountTotal" msprop:Generator_ColumnVarNameInTable="columnO_CouponDiscountTotal" msprop:Generator_ColumnPropNameInRow="O_CouponDiscountTotal" msprop:Generator_ColumnPropNameInTable="O_CouponDiscountTotalColumn" msprop:Generator_UserColumnName="O_CouponDiscountTotal" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_PricesIncTax" msprop:Generator_ColumnVarNameInTable="columnO_PricesIncTax" msprop:Generator_ColumnPropNameInRow="O_PricesIncTax" msprop:Generator_ColumnPropNameInTable="O_PricesIncTaxColumn" msprop:Generator_UserColumnName="O_PricesIncTax" type="xs:boolean" minOccurs="0" />
              <xs:element name="O_TaxDue" msprop:Generator_ColumnVarNameInTable="columnO_TaxDue" msprop:Generator_ColumnPropNameInRow="O_TaxDue" msprop:Generator_ColumnPropNameInTable="O_TaxDueColumn" msprop:Generator_UserColumnName="O_TaxDue" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_PaymentGateWay" msprop:Generator_ColumnVarNameInTable="columnO_PaymentGateWay" msprop:Generator_ColumnPropNameInRow="O_PaymentGateWay" msprop:Generator_ColumnPropNameInTable="O_PaymentGateWayColumn" msprop:Generator_UserColumnName="O_PaymentGateWay" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_ReferenceCode" msprop:Generator_ColumnVarNameInTable="columnO_ReferenceCode" msprop:Generator_ColumnPropNameInRow="O_ReferenceCode" msprop:Generator_ColumnPropNameInTable="O_ReferenceCodeColumn" msprop:Generator_UserColumnName="O_ReferenceCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_LanguageID" msprop:Generator_ColumnVarNameInTable="columnO_LanguageID" msprop:Generator_ColumnPropNameInRow="O_LanguageID" msprop:Generator_ColumnPropNameInTable="O_LanguageIDColumn" msprop:Generator_UserColumnName="O_LanguageID" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="O_CurrencyID" msprop:Generator_ColumnVarNameInTable="columnO_CurrencyID" msprop:Generator_ColumnPropNameInRow="O_CurrencyID" msprop:Generator_ColumnPropNameInTable="O_CurrencyIDColumn" msprop:Generator_UserColumnName="O_CurrencyID" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="O_TotalPriceGateway" msprop:Generator_ColumnVarNameInTable="columnO_TotalPriceGateway" msprop:Generator_ColumnPropNameInRow="O_TotalPriceGateway" msprop:Generator_ColumnPropNameInTable="O_TotalPriceGatewayColumn" msprop:Generator_UserColumnName="O_TotalPriceGateway" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_CurrencyIDGateway" msprop:Generator_ColumnVarNameInTable="columnO_CurrencyIDGateway" msprop:Generator_ColumnPropNameInRow="O_CurrencyIDGateway" msprop:Generator_ColumnPropNameInTable="O_CurrencyIDGatewayColumn" msprop:Generator_UserColumnName="O_CurrencyIDGateway" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="O_AffiliatePaymentID" msprop:Generator_ColumnVarNameInTable="columnO_AffiliatePaymentID" msprop:Generator_ColumnPropNameInRow="O_AffiliatePaymentID" msprop:Generator_ColumnPropNameInTable="O_AffiliatePaymentIDColumn" msprop:Generator_UserColumnName="O_AffiliatePaymentID" type="xs:int" minOccurs="0" />
              <xs:element name="O_AffiliateTotalPrice" msprop:Generator_ColumnVarNameInTable="columnO_AffiliateTotalPrice" msprop:Generator_ColumnPropNameInRow="O_AffiliateTotalPrice" msprop:Generator_ColumnPropNameInTable="O_AffiliateTotalPriceColumn" msprop:Generator_UserColumnName="O_AffiliateTotalPrice" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_SendOrderUpdateEmail" msprop:Generator_ColumnVarNameInTable="columnO_SendOrderUpdateEmail" msprop:Generator_ColumnPropNameInRow="O_SendOrderUpdateEmail" msprop:Generator_ColumnPropNameInTable="O_SendOrderUpdateEmailColumn" msprop:Generator_UserColumnName="O_SendOrderUpdateEmail" type="xs:boolean" minOccurs="0" />
              <xs:element name="O_OrderHandlingCharge" msprop:Generator_ColumnVarNameInTable="columnO_OrderHandlingCharge" msprop:Generator_ColumnPropNameInRow="O_OrderHandlingCharge" msprop:Generator_ColumnPropNameInTable="O_OrderHandlingChargeColumn" msprop:Generator_UserColumnName="O_OrderHandlingCharge" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_OrderHandlingChargeTax" msprop:Generator_ColumnVarNameInTable="columnO_OrderHandlingChargeTax" msprop:Generator_ColumnPropNameInRow="O_OrderHandlingChargeTax" msprop:Generator_ColumnPropNameInTable="O_OrderHandlingChargeTaxColumn" msprop:Generator_UserColumnName="O_OrderHandlingChargeTax" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_CurrencyRate" msprop:Generator_ColumnVarNameInTable="columnO_CurrencyRate" msprop:Generator_ColumnPropNameInRow="O_CurrencyRate" msprop:Generator_ColumnPropNameInTable="O_CurrencyRateColumn" msprop:Generator_UserColumnName="O_CurrencyRate" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_BillingAddress" msprop:Generator_ColumnVarNameInTable="columnO_BillingAddress" msprop:Generator_ColumnPropNameInRow="O_BillingAddress" msprop:Generator_ColumnPropNameInTable="O_BillingAddressColumn" msprop:Generator_UserColumnName="O_BillingAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_ShippingAddress" msprop:Generator_ColumnVarNameInTable="columnO_ShippingAddress" msprop:Generator_ColumnPropNameInRow="O_ShippingAddress" msprop:Generator_ColumnPropNameInTable="O_ShippingAddressColumn" msprop:Generator_UserColumnName="O_ShippingAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_PromotionDiscountTotal" msprop:Generator_ColumnVarNameInTable="columnO_PromotionDiscountTotal" msprop:Generator_ColumnPropNameInRow="O_PromotionDiscountTotal" msprop:Generator_ColumnPropNameInTable="O_PromotionDiscountTotalColumn" msprop:Generator_UserColumnName="O_PromotionDiscountTotal" type="xs:decimal" minOccurs="0" />
              <xs:element name="O_PromotionDescription" msprop:Generator_ColumnVarNameInTable="columnO_PromotionDescription" msprop:Generator_ColumnPropNameInRow="O_PromotionDescription" msprop:Generator_ColumnPropNameInTable="O_PromotionDescriptionColumn" msprop:Generator_UserColumnName="O_PromotionDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_SentToQB" msprop:Generator_ColumnVarNameInTable="columnO_SentToQB" msprop:Generator_ColumnPropNameInRow="O_SentToQB" msprop:Generator_ColumnPropNameInTable="O_SentToQBColumn" msprop:Generator_UserColumnName="O_SentToQB" type="xs:boolean" minOccurs="0" />
              <xs:element name="O_Notes" msprop:Generator_ColumnVarNameInTable="columnO_Notes" msprop:Generator_ColumnPropNameInRow="O_Notes" msprop:Generator_ColumnPropNameInTable="O_NotesColumn" msprop:Generator_UserColumnName="O_Notes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_ShippingMethod" msprop:Generator_ColumnVarNameInTable="columnO_ShippingMethod" msprop:Generator_ColumnPropNameInRow="O_ShippingMethod" msprop:Generator_ColumnPropNameInTable="O_ShippingMethodColumn" msprop:Generator_UserColumnName="O_ShippingMethod" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_Data" msprop:Generator_ColumnVarNameInTable="columnO_Data" msprop:Generator_ColumnPropNameInRow="O_Data" msprop:Generator_ColumnPropNameInTable="O_DataColumn" msprop:Generator_UserColumnName="O_Data" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_Comments" msprop:Generator_ColumnVarNameInTable="columnO_Comments" msprop:Generator_ColumnPropNameInRow="O_Comments" msprop:Generator_ColumnPropNameInTable="O_CommentsColumn" msprop:Generator_UserColumnName="O_Comments" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="O_Cancelled" msprop:Generator_ColumnVarNameInTable="columnO_Cancelled" msprop:Generator_ColumnPropNameInRow="O_Cancelled" msprop:Generator_ColumnPropNameInTable="O_CancelledColumn" msprop:Generator_UserColumnName="O_Cancelled" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InvoiceRows" msprop:Generator_UserTableName="InvoiceRows" msprop:Generator_RowEvArgName="InvoiceRowsRowChangeEvent" msprop:Generator_TableVarName="tableInvoiceRows" msprop:Generator_TablePropName="InvoiceRows" msprop:Generator_RowDeletingName="InvoiceRowsRowDeleting" msprop:Generator_RowChangingName="InvoiceRowsRowChanging" msprop:Generator_RowDeletedName="InvoiceRowsRowDeleted" msprop:Generator_RowEvHandlerName="InvoiceRowsRowChangeEventHandler" msprop:Generator_TableClassName="InvoiceRowsDataTable" msprop:Generator_RowChangedName="InvoiceRowsRowChanged" msprop:Generator_RowClassName="InvoiceRowsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IR_VersionCode" msprop:Generator_ColumnVarNameInTable="columnIR_VersionCode" msprop:Generator_ColumnPropNameInRow="IR_VersionCode" msprop:Generator_ColumnPropNameInTable="IR_VersionCodeColumn" msprop:Generator_UserColumnName="IR_VersionCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IR_VersionName" msprop:Generator_ColumnVarNameInTable="columnIR_VersionName" msprop:Generator_ColumnPropNameInRow="IR_VersionName" msprop:Generator_ColumnPropNameInTable="IR_VersionNameColumn" msprop:Generator_UserColumnName="IR_VersionName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IR_Quantity" msprop:Generator_ColumnVarNameInTable="columnIR_Quantity" msprop:Generator_ColumnPropNameInRow="IR_Quantity" msprop:Generator_ColumnPropNameInTable="IR_QuantityColumn" msprop:Generator_UserColumnName="IR_Quantity" type="xs:float" minOccurs="0" />
              <xs:element name="IR_PricePerItem" msprop:Generator_ColumnVarNameInTable="columnIR_PricePerItem" msprop:Generator_ColumnPropNameInRow="IR_PricePerItem" msprop:Generator_ColumnPropNameInTable="IR_PricePerItemColumn" msprop:Generator_UserColumnName="IR_PricePerItem" type="xs:decimal" minOccurs="0" />
              <xs:element name="IR_TaxPerItem" msprop:Generator_ColumnVarNameInTable="columnIR_TaxPerItem" msprop:Generator_ColumnPropNameInRow="IR_TaxPerItem" msprop:Generator_ColumnPropNameInTable="IR_TaxPerItemColumn" msprop:Generator_UserColumnName="IR_TaxPerItem" type="xs:decimal" minOccurs="0" />
              <xs:element name="IR_OptionsText" msprop:Generator_ColumnVarNameInTable="columnIR_OptionsText" msprop:Generator_ColumnPropNameInRow="IR_OptionsText" msprop:Generator_ColumnPropNameInTable="IR_OptionsTextColumn" msprop:Generator_UserColumnName="IR_OptionsText" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="V_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnV_ID" msprop:Generator_ColumnPropNameInRow="V_ID" msprop:Generator_ColumnPropNameInTable="V_IDColumn" msprop:Generator_UserColumnName="V_ID" type="xs:long" minOccurs="0" />
              <xs:element name="V_Live" msprop:Generator_ColumnVarNameInTable="columnV_Live" msprop:Generator_ColumnPropNameInRow="V_Live" msprop:Generator_ColumnPropNameInTable="V_LiveColumn" msprop:Generator_UserColumnName="V_Live" type="xs:boolean" minOccurs="0" />
              <xs:element name="V_Quantity" msprop:Generator_ColumnVarNameInTable="columnV_Quantity" msprop:Generator_ColumnPropNameInRow="V_Quantity" msprop:Generator_ColumnPropNameInTable="V_QuantityColumn" msprop:Generator_UserColumnName="V_Quantity" type="xs:short" minOccurs="0" />
              <xs:element name="V_Type" msprop:Generator_ColumnVarNameInTable="columnV_Type" msprop:Generator_ColumnPropNameInRow="V_Type" msprop:Generator_ColumnPropNameInTable="V_TypeColumn" msprop:Generator_UserColumnName="V_Type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CardTypes" msprop:Generator_UserTableName="CardTypes" msprop:Generator_RowEvArgName="CardTypesRowChangeEvent" msprop:Generator_TableVarName="tableCardTypes" msprop:Generator_TablePropName="CardTypes" msprop:Generator_RowDeletingName="CardTypesRowDeleting" msprop:Generator_RowChangingName="CardTypesRowChanging" msprop:Generator_RowDeletedName="CardTypesRowDeleted" msprop:Generator_RowEvHandlerName="CardTypesRowChangeEventHandler" msprop:Generator_TableClassName="CardTypesDataTable" msprop:Generator_RowChangedName="CardTypesRowChanged" msprop:Generator_RowClassName="CardTypesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CR_NAME" msprop:Generator_ColumnVarNameInTable="columnCR_NAME" msprop:Generator_ColumnPropNameInRow="CR_NAME" msprop:Generator_ColumnPropNameInTable="CR_NAMEColumn" msprop:Generator_UserColumnName="CR_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Payments" msprop:Generator_UserTableName="Payments" msprop:Generator_RowEvArgName="PaymentsRowChangeEvent" msprop:Generator_TableVarName="tablePayments" msprop:Generator_TablePropName="Payments" msprop:Generator_RowDeletingName="PaymentsRowDeleting" msprop:Generator_RowChangingName="PaymentsRowChanging" msprop:Generator_RowDeletedName="PaymentsRowDeleted" msprop:Generator_RowEvHandlerName="PaymentsRowChangeEventHandler" msprop:Generator_TableClassName="PaymentsDataTable" msprop:Generator_RowChangedName="PaymentsRowChanged" msprop:Generator_RowClassName="PaymentsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Payment_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPayment_ID" msprop:Generator_ColumnPropNameInRow="Payment_ID" msprop:Generator_ColumnPropNameInTable="Payment_IDColumn" msprop:Generator_UserColumnName="Payment_ID" type="xs:int" />
              <xs:element name="Payment_CustomerID" msprop:Generator_ColumnVarNameInTable="columnPayment_CustomerID" msprop:Generator_ColumnPropNameInRow="Payment_CustomerID" msprop:Generator_ColumnPropNameInTable="Payment_CustomerIDColumn" msprop:Generator_UserColumnName="Payment_CustomerID" type="xs:int" minOccurs="0" />
              <xs:element name="Payment_Date" msprop:Generator_ColumnVarNameInTable="columnPayment_Date" msprop:Generator_ColumnPropNameInRow="Payment_Date" msprop:Generator_ColumnPropNameInTable="Payment_DateColumn" msprop:Generator_UserColumnName="Payment_Date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Payment_Amount" msprop:Generator_ColumnVarNameInTable="columnPayment_Amount" msprop:Generator_ColumnPropNameInRow="Payment_Amount" msprop:Generator_ColumnPropNameInTable="Payment_AmountColumn" msprop:Generator_UserColumnName="Payment_Amount" type="xs:decimal" minOccurs="0" />
              <xs:element name="Payment_CurrencyID" msprop:Generator_ColumnVarNameInTable="columnPayment_CurrencyID" msprop:Generator_ColumnPropNameInRow="Payment_CurrencyID" msprop:Generator_ColumnPropNameInTable="Payment_CurrencyIDColumn" msprop:Generator_UserColumnName="Payment_CurrencyID" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Payment_ReferenceNo" msprop:Generator_ColumnVarNameInTable="columnPayment_ReferenceNo" msprop:Generator_ColumnPropNameInRow="Payment_ReferenceNo" msprop:Generator_ColumnPropNameInTable="Payment_ReferenceNoColumn" msprop:Generator_UserColumnName="Payment_ReferenceNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Payment_Gateway" msprop:Generator_ColumnVarNameInTable="columnPayment_Gateway" msprop:Generator_ColumnPropNameInRow="Payment_Gateway" msprop:Generator_ColumnPropNameInTable="Payment_GatewayColumn" msprop:Generator_UserColumnName="Payment_Gateway" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Payment_CurrencyRate" msprop:Generator_ColumnVarNameInTable="columnPayment_CurrencyRate" msprop:Generator_ColumnPropNameInRow="Payment_CurrencyRate" msprop:Generator_ColumnPropNameInTable="Payment_CurrencyRateColumn" msprop:Generator_UserColumnName="Payment_CurrencyRate" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>